05-08-2017
How to calculate percentages using Open Office Calc spreadsheet
05-08-2017
In this video tutorial, I will show you how to calculate percentages using Open Office Calc spreadsheet. Save yourself some time and use formulas to calculate percentages for small or big data sets.
27-05-2017
Top 5 Open Office Calc short cuts to save you time - Part 1
27-05-2017
This is a free video tutorial. In this video tutorial, I will show my top 5 Office Calc short cuts to save you time. (Part 1). Open Office is a free suite of office applications which you can download onto Windows, Linux and Apple Mac computers. Open Office contains an application Calc which is a spreadsheet application similar to Microsoft Office Excel.
23-05-2015
How to add gird lines to an open office calc spreadsheet
23-05-2015
In this tutorial, I will show you how to add gridlines to an open office calc spreadsheet.
10-05-2015
How to Calculate VAT using Open Office Calc spreadsheet
10-05-2015
In this tutorial, I will show you how to Calculate VAT using Open Office Calc Spreadsheet. We will use formulas to automatically calculate the VAT for any value.
13-02-2015
Open Office Calc Spreadsheets - Sort Columns - ascending order / descending order
13-02-2015
In this tutorial, I will show you how to sort columns in Open Office Calc using ascending order or descending order. Sorting columns in a spreadsheet can be useful when you need to analyse data. Sorting by date or name is often required when analysing large data sets in a spreadsheet.
13-02-2015
How to calculate average using open office calc tutorial
13-02-2015
In this tutorial, I will show you how to calculate the average using open office calc. Understanding how to calculate averages can be a very useful business tool. Averages can be used to give you an overview of different aspects of your business such as average fuel cost per month, average phone bill per month, average staff wages per year etc. In this tutorial will use OpenOffice Calc to create a spreadsheet and then calculate averages.
08-01-2015
Open Office Calc Auto Sum Function - Open Office Tutorial
08-01-2015
Open Office Calc Auto Sum Function - A simple video tutorial explaining auto sum function in Open Office Calc. The Auto Sum Function in Calc is useful when you simply what to add up all numbers in a row or column. This is especially useful when you are working on bookkeeping for your business.
23-08-2014
Bookkeeping for small business tutorial part 1 - open office calc spreadsheets
23-08-2014
This is a free video tutorial for small business bookkeeping - part 1 - open office calc spreadsheets - invoice tracking - bookkeeping training. In this video tutorial, I will show you how to keep track of invoices which you have sent to your clients. By the end of this tutorial, you will be able to keep track of all your invoices and know who has paid and more importantly how has NOT paid so you can chase up payments.
23-08-2014
bookkeeping for small business tutorial part 2 - open office calc spreadsheets - invoice template
23-08-2014
This is a free video tutorial for small business bookkeeping - part 2 - open office calc spreadsheets - invoice template design. In this 2nd bookkeeping, the tutorial will focus on designing a custom invoice template. We will design the invoice template from a blank spreadsheet document, the goal is not only to design a custom invoice but also give you a better understanding of how to layout documents using Open Office Calc.
23-08-2014
Bookkeeping for small business tutorial part 3 - open office calc spreadsheet - expenditure tracking
23-08-2014
In this final tutorial (I hope you made it this far) we will focus on creating an expenditure tracking spreadsheet. Wouldn't it be great if you could look at the spreadsheet and find out how much you have spent on fuel over a period of a month or year? Or how much you have spent on telephone bills or broadband costs?
23-08-2014
Open office calc basic formula tutorial
23-08-2014
In this video tutorial, I will show you how to use basic formulas in Open Office Calc. Using formulas in spreadsheets can help you speed up your workflow, data entry and analyse data quicker. I often use formulas to assist in complex spreadsheet calculations.
01-09-2013
Open Office 4 - Calc Spreadsheet Beginners Tutorial
01-09-2013
This is a free video tutorial I will aim to give you a basic understanding of Open Office 4 – Calc Spreadsheet. The goal of this video tutorial is to give you a fundamental understanding of how spreadsheets work. In this tutorial, we will use Open Office 4 Calc. We will cover various common aspects of spreadsheet applications. We will look at column data, row data, auto filters, cells, cell types, cell formatting, cell colour controls and much more.
01-09-2013
How to make a chart using Open Office 4 Calc Spreadsheet Video Tutorial
01-09-2013
In this video tutorial, I will show you how to make a chart using Open Office 4 Calc Spreadsheet. Creating charts can be a useful tool when you need to visualise data. For example, you may want to create a chart showing how much revenue you have generated over a specific period of time or make a cart to show how many customers visit your shop on a daily basis. The chart can be easily created using Open Office 4 Calc Spreadsheets.
